home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Precision Software Appli…tions Silver Collection 1
/
Precision Software Applications Silver Collection Volume One (PSM) (1993).iso
/
tutor
/
dbaseiii.exe
/
M201.T
< prev
next >
Wrap
Text File
|
1986-07-31
|
8KB
|
527 lines
*2-010
xÇÇÅ
rââ┘ Introduction to dBASE III PLUS
rÑâ∙∙
rªâ┘
r¿â┘Session 2
r▒â┘
r│â∙∙
r┤â┘
r╢â∙Create
r╝â┘ ö
râäτ ├─ ä
râàç ╬
râåç ╬
râçç ╬
râêç ╬
râëç å In this session, you will ¼
rÅìº■
rÆìÅCreate
rÿìç the structure for your database file
r╛ìç- ToDoList
rÅź■
rÆÅÅAppend
rÖÅçrecords to your file
rÅæº■
rÆæÅPrint
rÿæça copy of the contents of your file
rñù┘ Press
r¡ù∙──┘
r▒ù┘ to continue or
r─ù∙F5
rƗ٠to exit
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
*2-020
xÇÇ╨
rüà╨A>
röêÅ ▒
röëÅ To start up
róëçdBASE III PLUS
r░ëÅ, type Å
röèÅ ▒
röïÅ
ròï° dbase
r£ïÅ at the operating system prompt è
röîÅ ▒
röìÅ ƒ then press
r╛ì° ──┘
r─ìÅ
röÄÅ ▒
r╖ù╨ Ü
qâà╨K,,10A/I,,,, è
a7,G,,,,,
a8,P,,,,dbase à ,
a8,P,,,,dBASE à ,
a8,P,,,,DBASE à ,
*2-030
xÇÇ╨
rüüé Set Up
rëü╨ Create Update Position Retrieve Organize Modify Tools
r┼üé00:00:00 am
rüé╨╔ ô═╗
rüâ╨║
réâé Database file à
ròâ╨║
rüä╨║ ô─║
rüà╨║ Format for Screen ║
ríàÅ ¿
rüå╨║ Query ì ║
ríåÅ Your first step is to
r╣åçcreate
r┐åÅ a ê
rüç╨║ ô─║
ríçÅ ¿
rüê╨║ Catalog ï ║
ríêÅ database file. ÿ
rüë╨║ View Ä ║
ríëÅ ¿
rüè╨║ ô─║
ríèÅ ¿
rüï╨║ Quit dBASE III ä ║
ríïÅ Press
r⌐ï°
r¼ïÅ to open the
r║ïçCreate
r┴ïÅ menu.
rüî╨╚ ô═╝
ríîÅ ¿
rüòê
r╗òç
r╝òÅPress
r┴òç F5
r╟òÅto exit
r╬òç
rüùéASSIST è ║<A:>║ ù ║Opt: 1/6 ï ║ å ║ ç
q╧ÿ╨S,,,,,,
a7,G,,,,,
a8,P,,,,&H004D,
a8,P,,,,&H63,
a8,C,M002.T,,,&H003F,
*2-040
rüü╨ Set Up
rëüé Create
ræü╨ Update
rüé╨ ê ╔ Å═╗
rüâ╨ ê ║
rèâé Database file
rÖâ╨║
rüä╨ ê ║ Format ê ║
rüà╨ ê ║ View è ║
rüå╨ ê ║ Query ë ║
rúåÅThe option
r»åç Database file
r┴åÅis
rüç╨ ê ║ Report ê ║
rüê╨ ê ║ Label ë ║
rúêÅalready highlighted.
rüë╨ ê ╚ Å═╝
rüè╨ ò
rüï╨ ù
rúïÅ Press
r¡ï° ──┘
r│ïÅ to select it. å
rüî╨ û
q╧ÿ╨S,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
*2-045
rÜâ╨╔ ä═╗
rÜä╨║
r¢äé A:
rƒä╨║
rÜà╨║ B: ║
rÜå╨╚ ä═╝
rúåç á
rúêç ò
r╛ïÅdrive
r─ïçA
rüû╨Command: CREATE
r╢ùé2
q╧ÿ╨S,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
*2-050
rÜâ╨ å
rÜä╨ å
rÜà╨ å
ríà╨ ¿
rÜå╨ å
ríå╨ ¿
ríç╨ ¿
ríê╨ ¿
ríë╨ ¿
rüè╨ Å ╔ ▓═╗ à
rüï╨ Å ║ Enter the name of the file:
r»ïé ô
r┬ï╨ ║ à
rüî╨ Å ╚ ▓═╝ à
rÑìÅ ª
rÑÄÅ Type
r¡Ä° todolist
r╖ÄÅ and press
r├Ä° ──┘
r╔ÄÅ
rÑÅÅ ª
rÑÉÅ ª
rÑæÅ To correct any typing errors, use
rÑÆÅ the
r½Æç
r«ÆÅ,
r░ÆçIns
r│ÆÅ, and
r╣ÆçDel
r╝ÆÅ keys. ë
r╦Æê å
rÑôÅ ª
r╖ò╨ Ö
rüû╨Command: CREATE
ræû╨A:
q»ïéK,,20A/IT,,,,
a7,G,,,,,
a9,P,,,,list,
a9,P,,,,List,
a9,P,,,,LIST,
*2-060
rüü╨ ╨
rüé╨ ╨
rüâ╨
rëâ╨ » Bytes remaining: 4000
rüä╨ ╖
rüà╨╔ æ═╦ ì═╦ Ä═╦ û═╗
rüå╨║ CURSOR <-- --> ║ ä INSERT ║ à DELETE ║ Up a field: ä ä ║
rüç╨║ Char: ä ║ Char: Ins ║ Char: Del ║ Down a field: ä ║
rüê╨║ Word: Home End ║ Field: ^N ║ Word: ^Y ║ Exit/Save: ä ^End ║
rüë╨║
räë╨Pan: ä ^ ^ ║ Help: F1 ║
rñë╨Field: ^U ║ Abort: ë Esc ║
rüè╨╚ æ═╩ ì═╩ Ä═╩ û═╝
rüï╨ à Field Name Type à Width Dec ì Field Name Type à Width Dec
rüî╨ à ƒ═ ì ƒ═
rüì╨ 1
råìé è
rÉì╨
rÆìéCharacter
r¥ìé
róìé
rÑì╨ ª
rÑÄ╨ º
rÑÅ╨ ª
rüÉê
râÉÅ ─
r╟É╨
r╚ÉÇ
r╩ÉÅ ç
râæÅ You are now ready to define the
rÑæçstructure
r«æÅ of your database file.
r╟æ╨
r╚æÇ
r╩æÅ Press
râÆÅ ─
r╟Æ╨
r╚ÆÇ
r╩ÆÅ
r╠ÆçF5
r╬ÆÅ
râôÅ For the purposes of this introduction, remove the dBASE III PLUS
r╟ô╨
r╚ôÇ
r╩ôÅ to
râöÅ instructions box from the top of the screen by pressing
r╜ö° F1
r┴öÅ å
r╚öÇ
r╩öÅ exit
râòÅ ─
r╟òê
r╚òÇ
r╩òÅ ç
rüûê É
ræû╨
rüùéCREATE
rùùéTODOLIST
r»ùéField: 1/1
qåìéS,,,,,,
a7,G,,,,,
a8,P,,,,&H003B,
a8,C,M002.T,,,&H003F,
*2-070
xÇÇ╨
rÉâ╨ ¿ Bytes remaining: 4000
rüä╨ ╖
rüà╨ à
råà°Field Name
rÉà╨ Type à Width Dec ì Field Name Type à Width Dec
rüå╨ à ƒ═ ì ƒ═
rüç╨ 1
råçé è
rÉç╨
rÆçéCharacter
r¥çé
róçé
rïë°
ræëÅ ║
rïè°│
ræèÅ You can specify up to 4 things about each field. ê
rïï°│
ræïÅ The first is the ¿
rïî°│
ræîÅ ║
rïì°└───
ræìÅ
rôìçField Name
r¥ìÅ «
ræÄÅ ║
ræÅÅ The field names for this example are
r╕Åçwhat
r╝ÅÅ,
r╛Åçwho
r┴ÅÅ, ë
ræÉÅ
rôÉçphone
rÿÉÅ,
rÜÉçwhen
r₧ÉÅ,
ráÉçwhere
rÑÉÅ, and
r½Éçactivity
r│ÉÅ. ù
rææÅ ║
ræÆÅ Type
rÿÆ° what
r₧ÆÅ for the name of Field 1 and press
r┴Æ° ──┘
r╟ÆÅ.
ræôÅ ║
ræöÅ dBASE III PLUS converts what you type into uppercase.
ræòÅ ║
r╦ò╨ å
rüùéCREATE è ║<A:>║TODOLIST Å ║Field: 1/1 ë ║ å ║ ç
qåçéK,,10M/I,,,,
a7,G,,,,,
a8,P,,,,WHAT å ,
*2-080
råà╨Field Name
rÆà°Type
råçéWHAT
rÆçéC
rïëê ë
röë°
rÿëê ç
r┼ëÅ î
rïèê ë
röè°│
ròèê è
rƒèÅ The second field specification is Å
rüïê ô
röï°│
ròïê è
rƒïÅ ä
r┼ïÅ î
rëîê ï
röî°└ ê─
r¥îê
ríîçType
r┼îÅ î
rëìê û
r┼ìÅ î
rëÄÅ Ö
r┼ÄÅ î
rëÅÅ There are 5 types of fields in dBASE III PLUS: ÿ
rëÉÅ »
r┼ÉÅ î
rëæÅ à
rÄæçCharacter à Numeric å Date à Logical à Memo
r├æÅ Ä
rëÆÅ ╚
rëôÅ ╖
r└ôç┌ Ä─┐
r╨ôÅ
rëöÅ Press
ræö° ──┘
rùöÅ for an explanation of the 5 types. à
r┐öç │
r┴öÅ
r├öçF5
r┼öÅ to exit
r╧öç│
r╨öÅ
rëòÅ ╖
r└òç└ Ä─┘
r╨òÅ
qÆçéS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
*2-090
xÇÇÅ
rüâÅ ╟
rüàÅ å You determine the Field Type by its intended content. ò
rçê° Character C
rÖêº│
rƒêçCharacter
r¿êÅ is for any keyboard character:
r╟êç
rÖëº│
rƒëÅ ¿
r╟ëç
rÖèº│
rƒèÅletter, number, punctuation mark. ç
r╟èç
rüïç ç Numeric à N ä
rÖïº│
rÜïÅ ¡
r╟ïç
rüîç ÿ
rÖîº│
rƒîÅ ¿
r╟îç
rüìç ÿ
rÖìº│
rƒìÅFields containing names, addresses, and
r╟ìç
rüÄç ç Date ê D ä
rÖĺ│
rƒÄÅ ¿
r╟Äç
rüÅç ÿ
rÖź│
rƒÅÅtelephone numbers are character fields.
rêÉç ì
rÖɺ│
rêæçLogical à L
rÖæº│
rêÆç ì
rÖƺ│
rêôç ì
rÖôº│
rêöçMemo ê M
dÖöº││
ráùÅ
rúùç
rñù┘ Press
r¡ù∙──┘
r│ù┘to continue or
r─ù∙F5
rƗ٠to exit
r╨ùÅ
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
*2-100
rçêç Character C
rƒêçNumeric
rºêÅis for fields containing à
r─êç ä
rƒëÅ Ñ
rƒèÅnumbers used in calculations. ê
rçï° Numeric à N
rƒïÅ Ñ
rƒîÅ Ñ
rƒìÅFields used for an expense account or
r─ìç
rƒÄÅ Ñ
rƒÅÅfor bookkeeping are numeric. ë
r─Åç ä
rƒÆÅTelephone or identification numbers are å
rƒöÅkept in character fields, not numeric fields.
râù╕ F9 to review
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
a8,T,2-090,,,&H0043,
*2-110
rçïç Numeric à N
rçÄ° Date ê D
rƒêçDate
rúêÅ is for dates in the form:
r╜êç
rñëÅ Ö
rƒèç à
rñèÅ mm/dd/yy where å
r╗èç
ríîÅ
rƒîÅmm
róîÅis a 2-digit number for month. April is 04
rƒìç ª
rƒÄÅdd is a 2-digit number for day. April 1 is 04/01
rƒÅç ª
rƒÉÅyy is a 2-digit number for year.
rƒÆÅ æ April 1, 1986 is 04/01/86
rƒôÅ ¼
rƒöÅ ¡
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
a8,T,2-090,,,&H0043,
*2-120
rçÄç Date ê D
rçæ° Logical à L
rƒêçLogical
rªêÅ is for fields containing î
rºëÅ ñ
ráèçY
róèÅor
rñèç N
rºèÅ (yes/no) ¢
rºïÅ ñ
rƒîÅ
ráîçT
ríîÅ or
rñîç F
rºîÅ (true/false). ù
rºìÅ ñ
rƒÄÅ ░
rƒÅÅ"Acct_Paid" might be a logical field in
rƒÉÅa Customer Accounts Receivable file. è
rƒæÅThe "Acct_Paid" field would contain Y ä
rƒÆÅ(for yes) if the customer had paid the last
rƒôÅinvoice, or N (for no) if the customer hadn't
rƒöÅpaid.
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,P,,,,&H0D,
a8,C,M002.T,,,&H003F,
a8,T,2-090,,,&H0043,
*2-130
rçæç Logical à L
rçö° Memo ê M
rƒêçMemo
rúêÅ is for free-form notes related ä
rƒëÅ º
rƒèÅto that particular record. ì
rƒïÅ º
rƒîÅ º
rƒìÅFor example, you could use a memo field
rƒÄÅ º
rƒÅÅto keep notes on your customers. ç
r╞Åç
r╟ÅÅ
rƒÉÅ ª
rƒæç ¼
rƒÆÅThe memo field can be up to 5000 characters
r╩Æç
rƒôç ¼
r╦ôÅ
rƒöÅin length.
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,C,M202.T,,,&H0D,
a8,C,M002.T,,,&H003F,
a8,T,2-090,,,&H0043,
Æç
rƒôç ¼
r╦ôÅ
rƒöÅin length.
q╧ÿÅS,,,,,,
a7,G,,,,,
a8,C,M202.T,,,&H0D,
a8,C,M